﻿CREATE TABLE [dbo].[SenateEstimatesSearchResults] (
    [Id]                       NVARCHAR (100) NOT NULL,
    [Title]                    NVARCHAR (MAX) NOT NULL,
    [DateAppointed]            DATETIME       NOT NULL,
    [Status]                   NVARCHAR (MAX) NOT NULL,
    [Chamber]                  NVARCHAR (MAX) NOT NULL,
    [FoundInHansard]           BIT            NULL,
    [FoundInQuestionsOnNotice] BIT            NULL,
    [FoundInReport]            BIT            NULL,
    [Link]                     NVARCHAR (MAX) NOT NULL,
    [IndexedContent]           NVARCHAR (MAX) NOT NULL
);







